module.exports = {
  getConfigs : `SELECT * FROM PublishConfiguration`,

  getConfig: `SELECT * FROM PublishConfiguration WHERE Category=@category`,

  addConfig: `INSERT INTO PublishConfiguration (
    Category,
    GitBranch, 
    BuildCommand, 
    OnlineCommand, 
    GetBuildVersions, 
    GetOnlineVersions, 
    HarborRepositoryUrl
  ) VALUES(@category, @gitBranch, @buildCommand,
    @onlineCommand, @getBuildVersions, @getOnlineVersions, @harborRepositoryUrl);`,
  
  updateConfig: `UPDATE PublishConfiguration 
    SET 
      Category=@category,
      GitBranch=@gitBranch, 
      BuildCommand=@buildCommand, 
      OnlineCommand=@onlineCommand, 
      GetBuildVersions=@getBuildVersions, 
      GetOnlineVersions=@getOnlineVersions, 
      HarborRepositoryUrl=@harborRepositoryUrl
    WHERE Id=@id;`,

  removeConfig: `DELETE FROM PublishConfiguration WHERE Id=@id;`
}